Object is invalid or no longer set. (Error 3420)

You are attempting to reference an object that is no longer valid or has not been set.

Possible causes:

• The object has been closed.
• The object has been orphaned (the parent object has been closed or deleted).
• The object is out of scope.
• The object library is not registered in the Microsoft« Windows« Registry.
• You are trying to reference a method or property of the collection, but you have not assigned it to a variable first. For example, to reference the Name property, use the following:

  Dim dbsPublish As Database

  Set dbsPublish = OpenDatabase("BIBLIO.mdb")

  dbname = dbsPublish.Name